/*
 Navicat Premium Data Transfer

 Source Server         : mysql5.7
 Source Server Type    : MySQL
 Source Server Version : 50726
 Source Host           : localhost:3307
 Source Schema         : miss_u

 Target Server Type    : MySQL
 Target Server Version : 50726
 File Encoding         : 65001

 Date: 18/10/2021 19:13:24
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for miss_banner
-- ----------------------------
DROP TABLE IF EXISTS `miss_banner`;
CREATE TABLE `miss_banner` (
  `id` bigint(20) NOT NULL,
  `image` varchar(512) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `deleted` int(11) DEFAULT '1',
  `insert_time` timestamp NULL DEFAULT NULL,
  `update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `status` tinyint(4) DEFAULT NULL COMMENT '状态（1:正常,2:冻结,3:删除）',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of miss_banner
-- ----------------------------
BEGIN;
INSERT INTO `miss_banner` VALUES (1, 'https://img1.baidu.com/it/u=1658212502,567001803&fm=26&fmt=auto', NULL, 1, NULL, '2021-10-16 10:43:47', 1);
INSERT INTO `miss_banner` VALUES (2, 'https://img1.baidu.com/it/u=1658212502,567001803&fm=26&fmt=auto', NULL, 1, NULL, '2021-10-16 10:43:49', 1);
COMMIT;

-- ----------------------------
-- Table structure for miss_member
-- ----------------------------
DROP TABLE IF EXISTS `miss_member`;
CREATE TABLE `miss_member` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `cellphone` varchar(255) DEFAULT NULL,
  `create_date` datetime DEFAULT NULL,
  `icon` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `source_from` varchar(255) DEFAULT NULL,
  `status` tinyint(4) DEFAULT NULL,
  `update_date` datetime DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `create_by` bigint(20) DEFAULT NULL,
  `update_by` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKr0m13s7g8qcp96s2ocgrdyfd1` (`create_by`),
  KEY `FKrbshowjln5cjx60oc5mlgw93m` (`update_by`),
  CONSTRAINT `FKr0m13s7g8qcp96s2ocgrdyfd1` FOREIGN KEY (`create_by`) REFERENCES `sys_user` (`id`),
  CONSTRAINT `FKrbshowjln5cjx60oc5mlgw93m` FOREIGN KEY (`update_by`) REFERENCES `sys_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of miss_member
-- ----------------------------
BEGIN;
INSERT INTO `miss_member` VALUES (1, '13857232104', '2021-10-18 17:25:27', NULL, '123456', NULL, 1, '2021-10-18 17:25:27', '13857232104', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for miss_mine_spot
-- ----------------------------
DROP TABLE IF EXISTS `miss_mine_spot`;
CREATE TABLE `miss_mine_spot` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `create_date` datetime DEFAULT NULL,
  `sex` varchar(255) DEFAULT NULL,
  `spot_pool_id` bigint(20) DEFAULT NULL,
  `status` tinyint(4) DEFAULT NULL,
  `update_date` datetime DEFAULT NULL,
  `user_id` bigint(20) DEFAULT NULL,
  `wechat_number` varchar(255) DEFAULT NULL,
  `create_by` bigint(20) DEFAULT NULL,
  `update_by` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FK5q5tg9t330equkxbw4tn20tww` (`create_by`) USING BTREE,
  KEY `FKm00quk3g2bqexy726ltbhbx1v` (`update_by`) USING BTREE,
  CONSTRAINT `FK5q5tg9t330equkxbw4tn20tww` FOREIGN KEY (`create_by`) REFERENCES `sys_user` (`id`),
  CONSTRAINT `FKm00quk3g2bqexy726ltbhbx1v` FOREIGN KEY (`update_by`) REFERENCES `sys_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=162 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of miss_mine_spot
-- ----------------------------
BEGIN;
INSERT INTO `miss_mine_spot` VALUES (161, '2021-10-18 18:17:18', '男', 12, 1, '2021-10-18 18:17:18', 1, '121', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for miss_spot
-- ----------------------------
DROP TABLE IF EXISTS `miss_spot`;
CREATE TABLE `miss_spot` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `create_date` datetime DEFAULT NULL,
  `status` tinyint(4) DEFAULT NULL,
  `update_date` datetime DEFAULT NULL,
  `user_id` varchar(255) DEFAULT NULL,
  `wechat_number` varchar(255) DEFAULT NULL,
  `create_by` bigint(20) DEFAULT NULL,
  `update_by` bigint(20) DEFAULT NULL,
  `sex` varchar(255) DEFAULT NULL,
  `sex_code` int(4) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FKrlijs8uayuettf1p79wb37tjj` (`create_by`) USING BTREE,
  KEY `FK9c8opp8wiw1nxkgq8pcggsqw3` (`update_by`) USING BTREE,
  CONSTRAINT `FK9c8opp8wiw1nxkgq8pcggsqw3` FOREIGN KEY (`update_by`) REFERENCES `sys_user` (`id`),
  CONSTRAINT `FKrlijs8uayuettf1p79wb37tjj` FOREIGN KEY (`create_by`) REFERENCES `sys_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of miss_spot
-- ----------------------------
BEGIN;
INSERT INTO `miss_spot` VALUES (3, '2021-10-18 15:11:57', 1, '2021-10-18 15:11:57', '2', '121', NULL, NULL, '男', 1);
INSERT INTO `miss_spot` VALUES (7, '2021-10-18 19:03:15', 1, '2021-10-18 19:03:15', '1', '111', NULL, NULL, '男', 1);
COMMIT;

-- ----------------------------
-- Table structure for miss_spot_pool
-- ----------------------------
DROP TABLE IF EXISTS `miss_spot_pool`;
CREATE TABLE `miss_spot_pool` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `create_date` datetime DEFAULT NULL,
  `status` tinyint(4) DEFAULT NULL,
  `update_date` datetime DEFAULT NULL,
  `user_id` varchar(255) DEFAULT NULL,
  `wechat_number` varchar(255) DEFAULT NULL,
  `create_by` bigint(20) DEFAULT NULL,
  `update_by` bigint(20) DEFAULT NULL,
  `sex` varchar(255) DEFAULT NULL,
  `sex_code` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FKrlijs8uayuettf1p79wb37tjj` (`create_by`) USING BTREE,
  KEY `FK9c8opp8wiw1nxkgq8pcggsqw3` (`update_by`) USING BTREE,
  CONSTRAINT `miss_spot_pool_ibfk_1` FOREIGN KEY (`update_by`) REFERENCES `sys_user` (`id`),
  CONSTRAINT `miss_spot_pool_ibfk_2` FOREIGN KEY (`create_by`) REFERENCES `sys_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of miss_spot_pool
-- ----------------------------
BEGIN;
INSERT INTO `miss_spot_pool` VALUES (12, '2021-10-18 18:17:18', 1, '2021-10-18 18:17:18', '1', '121', NULL, NULL, '男', '1');
COMMIT;

-- ----------------------------
-- Table structure for miss_third_account
-- ----------------------------
DROP TABLE IF EXISTS `miss_third_account`;
CREATE TABLE `miss_third_account` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `bind_flag` varchar(255) DEFAULT NULL,
  `create_date` datetime DEFAULT NULL,
  `status` tinyint(4) DEFAULT NULL,
  `third_unique_account` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `update_date` datetime DEFAULT NULL,
  `user_id` varchar(255) DEFAULT NULL,
  `create_by` bigint(20) DEFAULT NULL,
  `update_by` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK589vh3nyhvl8qcqcws3l8ssp6` (`create_by`),
  KEY `FKi1pbum6kdqrtgwxf82gxwgqiq` (`update_by`),
  CONSTRAINT `FK589vh3nyhvl8qcqcws3l8ssp6` FOREIGN KEY (`create_by`) REFERENCES `sys_user` (`id`),
  CONSTRAINT `FKi1pbum6kdqrtgwxf82gxwgqiq` FOREIGN KEY (`update_by`) REFERENCES `sys_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

SET FOREIGN_KEY_CHECKS = 1;
